swap row titles and column titles

  • Thread starter Thread starter David
  • Start date Start date
D

David

Can you produce a database from an Excel spreadsheet but using the first
column as fields and the top row as records?

Many thanks,

David
 
David,

Copy the table, then paste it elswhere using Paste Special - Transpose.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unobtrusive Place To Put Report TItle and a List? 5
The next Grand Theft Auto title has been officially announced 0
comparing 2 columns 8
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Freeze Bottom Row 9
Get Name of Sheet to use in Macro 11
Hitting the limits with Excel and need about 1 million rows of data.What is the best option for what 1
title row 2

Back
Top