ATTENTION: You are viewing a page formatted for mobile devices; to view the full web page, click HERE.

Main Area and Open Discussion > General Software Discussion

Working with excel row and columns

<< < (2/2)

AndyM:
The real file has many more records of course.
-rgdot (April 07, 2014, 12:21 PM)
--- End quote ---

How many records (rows)?

Is this a one-time task?

AndyM:
?

skwire:
?-AndyM (April 08, 2014, 07:12 AM)
--- End quote ---

I banned the spammer (and his/her posts).

rgdot:
Thanks for the help/suggestions, will try/test them.

Pivot tables may be doable but I am not an expert. Not exactly a transpose.

@IainB I should post there, that's true. Not sure what to search for though, I mean what would be the search query, so yes post it is.
@AndyM. One time yes. ~40k rows.

TaoPhoenix:
Also checkout a free Excel addin called ASAP-Utilities.  It lets you transpose like that. 
-kunkel321 (April 07, 2014, 08:31 PM)
--- End quote ---

I've used ASAP-Utilities and I was impressed, even though I didn't need 95% of what it did.

Navigation

[0] Message Index

[*] Previous page

Go to full version