Excel Reporting assistance

[svsands26]

I have a delimina inwhich I'm trying to create a report, but the data is in one column but I'm trying to separate it out and put in another column.

The data looks like this:
Last Name Type Amount
Frog General $50
Frog Donation $75
Frog Payment $35


Desired Look
Last Name General Donation Payment
Frog $50 $75 $35

Is there a way to make this happen.

[bebo021999]

Have you tried SUMIFS?

=SUMIFS(C:C,A:A,"Frog",B:B,"General")

Replace "Frog","General" with reference (D$1 for instance) that contains it.

[cbatrody]

OR,

Try using a Pivot Table.

See the attached file.

[shukla.ankur281190]

Try

H3

Please Login or Register  to view this content.

Copy across

Row\Col	A	B	C	D	E	F	G	H	I	J
1	Last Name	Type	Amount
2	Frog	General	50				Last Name	General	Donation	Payment
3	Frog	Donation	75				Frog	50	75	35
4	Frog	Payment	35

[Sunny18pc]

Hi,
You can easily do this by following steps:
1. convert text to column(Alt+A+E)
2.Use a delimate space to separate the text.
3.Filter by last name
4.You can perform the desired working

If anything remains confusing. You can reply me.

[svsands26]

Thank you. I did use the Pivot Table function which did what I needed, and then I need to bring/import/export that to another file/table with other data which needed to be updated every two weeks. So I'm looking for an automation technique now. Do you think VBA will provide me the automation I need? Any suggestions?

OR,

Try using a Pivot Table.

See the attached file.

[JeteMc]

Since a period of 19 days elapsed, between the suggestion of using a pivot table and the question about exporting the pivot table data into another file, there are probably only a few people viewing this thread anymore. I would therefore recommend marking this thread as 'Solved', using the thread tools link above your first post (since the pivot table solves the original question). Then open a new thread and upload a sample of the data used to produce the pivot table, the pivot table itself and a sample of the "other data" to be exported. Also mock up, manually, the expected result table that will be in the other file.
I would also suggest including a link to this thread in your post, as it is possible that one of the other proposed solutions is more suitable for exporting.
To upload a sample workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.