Moving Excel Columns to Rowa

I found an article that shows how to move Excel columns to rows but it is painstaking - it seems I have to do it one by one

I am wanting to switch to eWallet by Ilium Software.  I was using PasswordBox but saw they were owned by MacAfee and Intel.  Plus I cannot get my passwords.  I am using LastPass as an alternative and it actually allowed me to download all my saved passwords in my browsers.

But I want a local program and eWallet seems to be the best.  They are supposed to be compatible with the export of SPB wallet but unfortunately there are some bugs.  

They have an FAQ How do I import data from a CSV file into eWallet?  I tried it with a couple - it seemed to work a bit better.

Here is an example of the export:


Commission Junction
Web Site:
User Name:
Password: password

Password: password
User Name: username
Notes: Acct Number: 123456


Bank of America
Card #: 4217000000000000
Card Type: Visa
Expires: 11/2013
PIN: 0000
CVV: 000
Owner: Owner Name
Bank: Bank of America
Lost Phone: 800-622-8731
Web Site:
User Name: username
Password: password
Acct Number: 123456789
Routing Numbers:
122000661 (paper)
121000358 (electronic)
026009593 (wires)

Affiliates is the folder and Commission Junction is a sub-folder, just like Regnow.

You will see two lines above Banks - this is a new folder and Bank of America is a subfolder.  

When exporting these, (and there are a lot), if I do not do it manually, it is really messed up.

They are supposed to be compatible with SPB Wallet: FAQ: How do I import data from other programs into eWallet? but not entirely.  

My possible option is moving the columns into rows but with over 500 passwords and other data, I need a quicker / easier way. FAQ: How do I import data from a CSV file into eWallet? shows the columns needed.

Fortunately, LastPass was very easy.  I guess I could go thru and see what passwords LastPass has and that might cut down on the SPB Wallet import.  I like the eWallet because I can customize it (for the most part - the templates are not as customizable as SPB wallet unfortunately.
Thank you
LVL 29
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Copy then paste special with the transpose option.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.