Data Transpose...

[@Gopigk]

Hi, I have huge data in vertical format, which I need to transpose horizontally, to work with Mail merge. But unable to do the same. My Original data and required data formats are below.

Please help

Original Data:

Name Inv no
A Inv#1
A Inv#2
A Inv#3
B Inv#4
B Inv#5
C Inv#6
C Inv#7
C Inv#8
C Inv#9
D Inv#10

Required format

A Inv#1 Inv#2 Inv#3
B Inv#4 Inv#5
C Inv#6 Inv#7 Inv#8 Inv#9
D Inv#10

Thanks in advance

 

[vletm]

@Gopigk
Press [ Do It ]-button... (once!)

 

[@Gopigk]

Hello Vletm, Thank you very much.Great work done. But it is not working in my file, where my original data exists. I copied the same macro in my excel sheet and run, but nothing happened. Please suggest. I am using 2016 version

 

[AlanSidman]

Suggest you upload a sample workbook that is representative of your actual file. In this manner we can test our code to make sure it works on your data.

 

[vletm]

@Gopigk
1) Are marcos possible to use with Your file?
2) Is Your original data's layout as in my file?
3) Where did You copy it?
4) If any of those is 'no' then You should upload a sample of Your file here as prev reply has written.

 

[@Gopigk]

Hi Vletm

I am Okay with your Macro and getting the result, when I copied my data into your file. whereas, when I tried to copied your Macro in to my workbook (Developer>VB>Sheet1@ Code writing area), it is not working. My file is compatible for Macro's and Layout is as same as your file. But I don't know where I'm making mistake is?

Anyway, thank you very much for your great support

 

[vletm]

@Gopigk
Your file's cell B2. What is there?
There should be word like 'Name' as in my code.