Help required on Transpose the big set of Data

[amb2301]

Hi Friends,
i have excel report, contains datas in A & B column & B column contains the keywords/repeated values..
Here based on the B column i need to transpose the datas from Vertical to Horizontal as shown in attached screenshot,
could someone please help me to do it.


i m unable to upload the Excel file, will try to compress & upload it

Thanks in Advance.

[alansidman]

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

[amb2301]

sorry Mr.Alan,
i will upload it in few mins, as the file size is big, i m struggling to upload it,
please give me sometime

Thanks

[amb2301]

compressed & attached file

[amb2301]

Could someone please help me with vba / formula

[AliGW]

Administrative Note:

We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day - you have posted three times today. Thanks for your understanding and patience.

[amb2301]

Administrative Note:

We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day - you have posted three times today. Thanks for your understanding and patience.

i m sorry Ali, its was bit urgent, so only i asked for Help.
I understand that you guys are busy on looking multiple threads....i will wait for it....Sorry again

[jindon]

No clear logic about the data and your result, so if this is not what you want, ignore this.

Please Login or Register  to view this content.

[kvsrinivasamurthy]

Here is the code

Please Login or Register  to view this content.

[amb2301]

Thank you so much for your code Sir, it saved my 2 days work.....its a great help for me...
Heartfelt Thanks Sir

[AliGW]

i m sorry Ali, its was bit urgent

Don't tell us that it is URGENT, please. To you it may be, but to us it isn’t. If it’s urgent, you should really be calling on a consultant, not a volunteer who is giving their free time.

I understand that you guys are busy on looking multiple threads

And doing oour day jobs ... We are volunteers, not employed and paid to serve.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[amb2301]

No clear logic about the data and your result, so if this is not what you want, ignore this.

Please Login or Register  to view this content.

Thank you so much for spending your Valuable time Jindow, it worked partially
(i mean some data's getting collapsed in same column)

[kvsrinivasamurthy]

Welcome. Pl mark the thread solved.