I am attempting to format my spreadsheet from a row form to a column form with a unique id

**xsbucks007** · 11-27-2012, 06:51 PM

Trying to play with relationships and easy way to manipulate sheets.

I am quite new to excel and have a csv file that i need to import into a CMS Component. I am hoping for a bit of help on how to do it as it has reached out passed my excel skills. I am sure its quite easy for most of you.... Here Goes....

The Files are uploaded as attachments, I hope i did this right.

I have a unique ID that will before each 'Before' Listing row. Which will be the value of Column 'D' in the after file.

**dilipandey** · 11-28-2012, 03:53 AM

Hi xsbucks,

How you are getting Id and fieldid in After sheet ?
I got that the last column Entry_id will change with new record.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**xsbucks007** · 11-28-2012, 09:04 AM

Thanks for your reply, I forgot to add the entry id into the row, but yes the entry ID will be identified prior to calculations

**dilipandey** · 11-29-2012, 02:09 AM

Okay.. if you can take care of those IDs, then try using below formula to fetch data.. see the attached files :-
Before.xlsx
After.xlsx

Formula:

Please Login or Register  to view this content.

Regards,
DILIPandey

<click on below 'star' if this helps>

**xsbucks007** · 11-30-2012, 04:43 PM

Thank you for your help! I really appreciate it. I am quite new to excel and am not sure where to put this formula to make the after values correct...

**xsbucks007** · 11-30-2012, 06:07 PM

I got it! Thank you so much for your help.

**dilipandey** · 12-01-2012, 03:36 AM

you are welcome..

Suggest you to mark this thread as [SOLVED].. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**xsbucks007** · 12-15-2012, 01:37 PM

That worked amazing! Thank you for your help!

**dilipandey** · 12-15-2012, 02:01 PM

Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>

I am attempting to format my spreadsheet from a row form to a column form with a unique id

LinkBack

Thread Tools

Rate This Thread

Display

I am attempting to format my spreadsheet from a row form to a column form with a unique id

Re: I am attempting to format my spreadsheet from a row form to a column form with a uniqu

Re: I am attempting to format my spreadsheet from a row form to a column form with a uniqu

Re: I am attempting to format my spreadsheet from a row form to a column form with a uniqu

Re: I am attempting to format my spreadsheet from a row form to a column form with a uniqu

Re: I am attempting to format my spreadsheet from a row form to a column form with a uniqu

Re: I am attempting to format my spreadsheet from a row form to a column form with a uniqu

Re: I am attempting to format my spreadsheet from a row form to a column form with a uniqu

Re: I am attempting to format my spreadsheet from a row form to a column form with a uniqu

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions