Cross Table Help

[m_perreault]

Hi All I have the below table.  The columns '5555','6666','7777' are ParentID's and their values are ownership percentages of the ChildID in column 1

ChildID	Description	MonthEnd	5555	6666	7777
5005	ABC Company	Jan18	.333	.333	.333
5005	ABC Company	Feb18	.5	.25	.25
5005	ABC Company	March18	.5	.5	0

I'd like to use the cross table function to create the below table does anyone have any ideas?

ChildID	Description	MonthEnd	ParentID	Ownership %
5005	ABC Company	Jan18	5555	.333
5005	ABC Company	Jan18	6666	.333
5005	ABC Company	Jan18	7777	.333
5005	ABC Company	Feb18	5555	.5
5005	ABC Company	Feb18	6666	.25
5005	ABC Company	Feb18	7777	.25
5005	ABC Company	March18	5555	.5
5005	ABC Company	March18	6666	.5
5005	ABC Company	March18	7777	0

[m_perreault · Accepted solution]

It was simpler than I realized

CrossTable([Parent ID],Ownership,3)

Load *

From MyTable