Transpose Column wise data into Row wise w.r.t using macro

Hello,

How to transpose row data into columnar wise,by making 2 columns distinct... such that specific rows are transposed into columns w.r.t Column A, Column B (Column A+ Column B -->Distinct) ...


Manually i can use transpose option but for more records, it will be time consuming.
How we can achieve this using macro function.

I enclosed a file attachment..

Please suggest.

Thanks,
Thara

This should do.

Please Login or Register  to view this content.

Hello,

Thanks for the response,
but when i execute this code getting error like

BASIC runtime error.
Object variable not set.

and it is highlighting in the syntax...

Application.ScreenUpdating = False

Please suggest..

Thanks,
Thara

Did you try the file I have attached?

I have no idea why you are getting such error on that line of code.

Hi,

Exactly i tried the attachment file..
if i execute macro then i am facing that error..
i am using Centos 7 (Linux) Libre office.

in this office i am executing the command...

Please suggest..

Thanks,
Thara

I think you should find Linux/Libre office help forum....

Thank you,
then i will try to execute in Windows Microsoft office - excel..
Hope my problem get resolved...


Thanks,
Thara

Try it with Excel first, this is Excel help form.

Hello,

Thank you for the guidelines..
It is work fine in windows Microsoft office -excel

Thanks,
Thara