Hello,
I want to transpose specific cells as shown in the below example. Request help on how this can be done


Project A Q3 10 Q3 Q4
Project A Q4 15 Project A 10 15
Project B Q3 20 ---> Project B 20 12
Project B Q4 12 Project C 7 5
Project C Q3 7


Project C Q4 5

Hi and welcome
please post a sample sheet ( click Go advanced - manage attachments) showing some data and expected results - Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi Pecoflyer, Please find the attachment that contains the sample data and the expected output

Attached Files

Transpose_Select_Cells.xlsx (9.2 KB, 10 views)

How about simply using a pivot table!

Attached Files

Transpose_Select_Cells (1).xlsx (13.1 KB, 8 views)