Populate Date For Data Grouping from Web Table 1

[gall3on]

I have a table that has data copied from a webpage table report.

The table when pasted in Excel has a format like this:

Date Group ColX ColY
10/31 A 1 3
B 2 5
C 4 2
11/1 A 1 0
C 2 1
11/2 B 4 5
11/3 A 3 0
B 1 0

And so on and so forth... The problem is, I want to do a pivot from here using the date and use this same data in a summary worksheet on that same workbook. But since the date is only really 'attached' to the column data that it is next to, it does not recognize the other data that should be attributed to that date. This table grows as each day passes and the values for ColX and ColY may change.

What kind of script can I use (or maybe there's something already built-in in Excel) that would allow me associate the ignored data for that specific date? In other words, I need the 10/31 date to show all A, B, C data on a pivot table. Also, I want to be able to import this data into an Access Database for further querying.

At the very least, I want the table to look like this after the script:

Date Group ColX ColY
10/31 A 1 3
10/31 B 2 5
10/31 C 4 2
11/1 A 1 0
11/1 C 2 1
11/2 B 4 5
11/3 A 3 0
11/3 B 1 0

Thanks!

 

[SkipVought]

Hi,

This is a VBA coding forum. Have you worked with VBA code before and, if so, what code have you generated so far to address this issue and where are you experiencing problems?

There are other ways to solve this problem. You might want to post in Forum68 for a spresdsheet solution.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[AnotherHiggins]

You may want to see thread68-1388904.

If you are manually populating this data on a daily basis, I would definitely just fill in the dates manually (using Fill Handle) since it would only take about 1 second.

But, as Skip said, if you want to pursue non-VBA solutions (which I would suggest unless you are automating the entire process), you should post a new thread in forum68.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[gall3on]

I was considering automating this but since I have a short ETC for the report for now, I will have to forego the VB script or do it steps by steps.

Thanks for the info though! I got the temporary solution that I need.