Transposing data

[kd81]

Hello,

I have a list of customer and their total sales per months. See below


123456789101112Smith1,4611,3671,4611,4141,4611,4141,4611,4611,4141,4611,4141,461Jones4,0923,8284,0923,9604,0923,9604,0924,0923,9604,0923,9604,092Davidson1,1691,0941,1691,1311,1691,1311,1691,1691,1311,1691,1311,169Miller1,1691,0941,1691,1311,1691,1311,1691,1691,1311,169849877Johnson 1,1691,0941,1691,1311,1691,1311,1691,1691,1311,1691,1311,169Edwards 1,1691,0941,1691,1311,1691,1311,1691,1691,1311,169849877Jackson1,7541,6411,7541,6971,7541,6971,7541,7541,6971,7542,2632,338Ford1,4611,3671,4611,4141,4611,4141,4611,4611,4141,4611,9802,046Clarckson2,0461,9142,0461,9802,0461,9802,0462,0461,9802,0461,9802,046


I would like to put it in the format below:

Customer Month Total SalesSmith 11,461Smith 21,367Smith 31,461Smith 41,414Smith 51,461Smith 61,414Smith 71,461Smith 81,461Smith 91,414Smith 101,461Smith 111,414Smith 121,461Jones14,092Jones23,828Jones34,092Jones43,960Jones54,092Jones63,960Jones74,092Jones84,092Jones93,960Jones104,092Jones113,960Jones124,092

.....etc

I have a very big file and I cant do it one by one.

I would be grate ful to you if you could assist

Thank you!

KD

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=574990

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).