Basic transform has me stuck

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)

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

staff.transform (2.1 KB)

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

1 Like