Macro help on unconsolidating

[bmatthewstevens]

I need help unconsolidating data, sorta the opposite of multiple consolidation ranges...

Any help would be highly appreciated.


The data I have

GL Number	IVNUM	Charge Description	Financial Class	Qty	Charges	Total Qty	Total Charges
10000.000	99003	BALANCE TRANSFER	MEDICARE	658​	2,844.62
10000.000			MEDICAID	42​	3,106.39
10000.000			BLUE CROSS	692​	(2,576.55)
10000.000			COMMERCIAL	643​	(4,903.98)
10000.000			HMO/PPO		-
10000.000			PRIVATE	1022​	1,614.98	3057​	85.46
10203.000	9903000	TRANSFERS TO/ FROM SURGERY CLINIC	MEDICARE		-
10203.000			MEDICAID		-
10203.000			BLUE CROSS	1​	148.15
10203.000			COMMERCIAL		-
10203.000			HMO/PPO		-
10203.000			PRIVATE		-	1​	148.15
10234.000	99006	REFUND FROM AR	MEDICARE	62​	35,987.42
10234.000			MEDICAID	27​	2,336.62
10234.000			BLUE CROSS	441​	56,376.17
10234.000			COMMERCIAL	119​	33,105.98
10234.000			HMO/PPO		-
10234.000			PRIVATE	13​	1,141.38	662​	128,947.57

What I need it to look like

GLNUM	IVNUM	Desc	Medicare QTY	Medicare AMT	Medicaid QTY	Medicaid AMT	BC QTY	BC AMT	COM QTY	COM AMT	HMO/PPO QTY	HMO/PPOAMT	Private QTY	Private AMT	Total Qty	Total Charges
10000.000	99003	BALANCE TRANSFER	658	2,844.62	42	3,106.39	692	(2,576.55)	643	(4,903.98)			1022	1,614.98	3057​	85.46
10203.000	9903000	TRANSFERS TO/ FROM SURGERY CLINIC		$0.00		$0.00	1	148.15		$0.00			1	148.15	1​	148.15
10234.000	99006	REFUND FROM AR	62	35,987.42	27	2,336.62	441	56,376.17	119	33,105.98			13	1,141.38	662​	128,947.57

 

[Peter_SSs]

Duplicate to: Unconsolidate data

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.