How to convert table from one form to other form?

SarahDetroja

New Member
Joined
May 13, 2020
Messages
18
Office Version
  1. 2013
Platform
  1. Windows
Hello Fellow Experts,

I have a table in the form of "INPUT" format. I want to convert that table in the form of "OUTPUT" format. What is the best way to do that?

Here is the link to the source file and also attached image

There is a Previous thread. Peter has solved a similar problem quite magnificently. However, my programming skill is not good so I can't able to leverage it myself.

Many thanks in advance for your kind help.

Note1: The number of rows can be any number
Note2: The number of columns can be any number
Note3: Assume date format will be consistent
Note4: Here "Email" and "Created Date" has been considered. It would be great to get flexibility so we can use any field as row and column


Regards
Sarah.
 

Attachments

  • Image1.png
    Image1.png
    55.1 KB · Views: 10

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Further note:
1. I have highlighted it just for a better understanding.
2. Raw data would be not grouped/sorted like "Email" and "Created Date" so it would appear as it has been entered by users.
 
Upvote 0

Forum statistics

Threads
1,223,885
Messages
6,175,186
Members
452,615
Latest member
bogeys2birdies

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top