I have a schedule I need to transpose with a lot of data. Any tips, tried transpose but was unsuccessful.
Read in the data from the header line (avoid the first row basically), Transpose the data (selecting the four account columns as Data columns and all the others as Key columns), and finally use a Formula to parse out Act No from the Name column!
@alexnajm Thank you! That worked!
