Basic transform has me stuck

Question
1

Trying to get the data in the spreadsheet into this format A,B,C. I cant use transpose>concat because I will never know how many rows will be in column A. There could be 2 or 20 depending on the week.

Example.csv (20 Bytes)

2

You can do it with Unique if you add a fake key column.

image
image744×130 33.1 KB

staff.transform (2.1 KB)

3

This is perfect. Appreciate it as always. no way I would have thought about that.

1 Like