Data from Rows to Column

[Krishna Prasad]

Hi,

Greetings!!

I am looking for help from experts to convert row data into column, I have attached file which contains 2 sheets named Data & Results.

Sheet named "Data" contains raw data where JB No is unique and rest of the data can be repeated.

Sheet named "Results" should be the output from macro which can fetch data from "Data" and reorganized.

Thanks in advance,

KP

 

[bobhc]

Hope this link helps.

http://www.howtogeek.com/howto/12366/convert-a-row-to-a-column-in-excel-the-easy-way/


.

 

[azumi]

Solution just for your example

 

[Asheesh]

Hi,

Sharing it since I worked on it

 

[Krishna Prasad]

Solution just for your example

Hi azumi,

Thanks that's working on example file, I will try on actual file where I have 500+ rows. I will revert to you if I need more help.

Since I have 500+ rows I would need some time to copy and past formula. Is there any VBA way?

Thanks for the help.

Regards,

KP

 

[Krishna Prasad]

Hi,

Sharing it since I worked on it

Hi Asheesh,

Thanks for the example, I need to try on actual file where I have 500+ rows. I will revert to you if I need more help.

Please let me know if there is any VBA way?

Thanks for the help.

KP

 

[Somendra Misra]

Hi azumi,

Thanks that's working on example file, I will try on actual file where I have 500+ rows. I will revert to you if I need more help.

Since I have 500+ rows I would need some time to copy and past formula. Is there any VBA way?

Thanks for the help.

Regards,

KP

Hi KP,

Will the device & device ID be always 3 ?

Regards,

 

[Krishna Prasad]

Hi KP,

Will the device & device ID be always 3 ?

Regards,

Hi,

Not necessarily, it can go upto 8.

Regards,

KP

 

[Asheesh]

Yes, it can be done using VBA but before I proceed to write VBA snippet for this...you may have to answer a few questions..

 

[Krishna Prasad]

Yes, it can be done using VBA but before I proceed to write VBA snippet for this...you may have to answer a few questions..

Please let me know your questions

KP

 

[Somendra Misra]

Hi,

Not necessarily, it can go upto 8.

Regards,

KP

Hi,

See this file, based on your input please see this file. Please note all the constants in the code is based on your sample file, which may need to be changed on actual file.

Before implementing on actual file make a copy of it, and work on that.

Regards,

 

[Krishna Prasad]

Hi,

See this file, based on your input please see this file. Please note all the constants in the code is based on your sample file, which may need to be changed on actual file.

Before implementing on actual file make a copy of it, and work on that.

Regards,

Hi Somendra,

I really thank for your help. It seems to be working, I would need to modify code a bit, which I should be able to manage, if I have any further query I will revert to you.

Thanks once again

KP

 

[Somendra Misra]

Glad you solved it. Welcome bck.

Regards,