How to turn columns of data into a table

[CYCBurner]

Hi all.

I have columns of time card data listed like so:

Dept.	Name1	Day1	Hrs
Dept.	Name1	Day2	Hrs
Dept.	Name1	Day3	Hrs
Repeat...	for...	whole...	month...
Dept.	Name2	Day1	Hrs
Repeat...	for...	60+...	employees...

I want to create a table that goes like so:

Name	Department	Date1	Date2	Date3	Date4	Date5
Name1	Dept	Hrs	Hrs	Hrs	hrs
Name2	Dept	Hrs	Hrs	Hrs	hrs
Name3	Dept	Hrs	Hrs	Hrs	hrs

Starting with zero coding experience (aside from with my ti-80 in middle school), I have tried to make a VBA macro using YouTube tutorials that does this, and I feel I've gotten close, but there's also something wrong with it and it is taking too much time. There are over a thousand rows.

I would appreciate any advice or help.

[maniacb]

Welcome to the forum. Can you upload your file so we can assist, as per the yellow banner above.

[AlphaFrog]

Looks like a job for a Pivot Table. Dates across the columns, Names on the Rows, Hours as the "data", and Dept in the "Page" Area.

Screenshot 2020-09-23 121104.jpg