Convert Rows to Columns?

Hello,

Attached is an example of data that needs to summarized, where the times (12AM-11:30PM) need to be in the row section on the Left and the days of the week need be be in the columns at the top. Anyway can automatically be done?



Attachment 235949PivotExample1.xlsx

First I ran the macro Sub CONVERTROWSTOCOL()

After that I made an pivot table.

See the attached file.

Alt + F11

On the left side of the VBA editor your will find module 1.

If you click on module 1 you find the code on the right side of your window.

You can copy this code and paste it in your workbook.

For that you open VBA editor:

Alt + F11

Inserts module

Then you can paste the code (which you copied) in the window of this module.

After that you can run the macro in your new workbook.

Please Login or Register  to view this content.

The sheet you need to change is marked with red tekst.

Please Login or Register  to view this content.

already in the above code.

this line will add an new worksheet with the name output.

if you don't want to add an new workbook (if it already exist), you have to put an ' for the line.

See if this is what you want.

Maybe like this?