Is there a function or macro that will put each field in a seperate column accross the sheet
A1= vimHOLDINGS_0.Symbol, vimHOLDINGS_0.GroupInvId, vimHOLDINGS_0.Ticker, vimHOLDINGS_0.QuantityShort, vimHOLDINGS_0.QuantityLong, vimHOLDINGS_0.Portfolio, vimHOLDINGS_0.SharesOutstanding, vimHOLDINGS_0.MarketValue, vimHOLDINGS_0.InvType, vimINVESTMENTS_0.InvDesc, vimINVESTMENTS_0.Region, vimINVESTMENTS_0.ExposureSector, vimHOLDINGS_0.Date
I want
B1 = vimHOLDINGS_0.Symbol
C1 = vimHOLDINGS_0.GroupInvId
D1 = vimHOLDINGS_0.Ticker
etc.
The cells do not have the same number for fields, they will have 1- 15 fields
A1= vimHOLDINGS_0.Symbol, vimHOLDINGS_0.GroupInvId, vimHOLDINGS_0.Ticker, vimHOLDINGS_0.QuantityShort, vimHOLDINGS_0.QuantityLong, vimHOLDINGS_0.Portfolio, vimHOLDINGS_0.SharesOutstanding, vimHOLDINGS_0.MarketValue, vimHOLDINGS_0.InvType, vimINVESTMENTS_0.InvDesc, vimINVESTMENTS_0.Region, vimINVESTMENTS_0.ExposureSector, vimHOLDINGS_0.Date
I want
B1 = vimHOLDINGS_0.Symbol
C1 = vimHOLDINGS_0.GroupInvId
D1 = vimHOLDINGS_0.Ticker
etc.
The cells do not have the same number for fields, they will have 1- 15 fields