• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Combine mulitple rows and columns into 1 row

M

msquared99

Member
I have a spreadsheet where I could have an EE's name listed once with data in columns B & C, they could also be listed again in a second row with data in columns D & E and they could also be listed again in a third row with data in coulmns F & G.

Some EE's have data listed only once in one of the three column sets where others may have two or three rows.

What I would like to be able to do is list the EE only once and list all the data from the column sets in one row instead of 1,2, or 3 rows.

Suggestions?

Thanks,

Mike
 
AHHHHAAA!

Solved it, go to the Data tab, choose Consolidate.

Choose Product then the range of data and include the labels.

Done!

What is even cooler is using VBA to do it.
 
You must log in or register to reply here.
Back
Top