I need to have a formula that will do conditional Transposing.
For each group of values in column B, transpose the usage coding in columns A to separate rows in column C, D, E…N. Please see the attached file and the desired outcome in rows 1-12 columns C-F.
There are about 2500 rows in the file.
I need this formula ASAP. When bidding, Please let me know when you’ll have it ready