Forum Discussion
Solved
Tranpose Data
Please can anyone assist me on how I can easily transpose this data on the left A-C so it looks like the one on the right E-G, the idea is to have a simple order sheet for the client to add the quant...
Mikedem007 With Excel for MS365 or Excel for the web:
=LET( names, B3:C3, codes, A4:A8, data, B4:C8, is_data, NOT(ISBLANK(data)), HSTACK( TOCOL(IFS(is_data, names), 2, TRUE), TOCOL(IFS(is_data, codes), 2, TRUE), TOCOL(data, 1, TRUE) ) )Unpivot: Remove Blanks
Mikedem007 With Excel for MS365 or Excel for the web:
=LET(
names, B3:C3, codes, A4:A8, data, B4:C8,
is_data, NOT(ISBLANK(data)),
HSTACK(
TOCOL(IFS(is_data, names), 2, TRUE),
TOCOL(IFS(is_data, codes), 2, TRUE),
TOCOL(data, 1, TRUE)
)
)
Unpivot: Remove Blanks
