How to Swap Rows and Columns in Excel

In Cue Office, use Paste Special → Transpose to swap rows and columns in an Excel workbook for a finished report. For an attendance sheet you still update, use Cue AI to create a transposed table that follows changes to the original.

Swap rows and columns with Paste Special

Open your sign-in workbook (.xlsx) in Cue Office, select A1:E4, and copy it, including the weekdays in the first row and the workshop names in the first column. A 4-row, 5-column range will occupy 5 rows and 4 columns after transposition. First confirm that A7:D11 is blank, then click top-left cell A7.

Original sign-in sheet with workshops as rows and weekdays as columns
Include both weekdays and workshop names when copying.

Click the Home tab at the top, expand the Paste Special drop-down menu, and click Paste Special…. In the dialog that appears, check Transpose and click OK.

Paste Special button and drop-down arrow in the Home toolbar
Click the drop-down arrow next to Paste Special.

Check the transposed table

Save and reopen the workbook. Weekdays should run down the left, with workshop names across the top. On Monday, 12 people attended the Repair workshop. That count is in B2 in the original and B8 in the transposed table.

After transposition, workshop names are at the top and weekdays are on the left
The three attendance figures for Monday are 12, 9, and 16.

For the text and numbers in this example, Paste Special creates a snapshot. If you change B2 to 99 later, the pasted B8 stays at 12.

Create a transposed table that updates with Cue AI

While an event is still ongoing, colleagues may want to see the latest attendance by day. Open another copy of the original table and keep A7:D11 blank to leave room for the linked table.

Under Home, click Cue AI and send the prompt below.

Home toolbar and Cue AI sidebar
Open Cue AI from Home and send instructions in the sidebar.
Could you turn the rows in A1:E4 into columns and put the new table starting at A7? I’d like the new table to update when I edit the original, and please keep the original table as it is.

Cue AI entered =TRANSPOSE(A1:E4) in A7. The formula fills A7:D11. Save, close, and reopen the workbook, then select A7 and check the formula bar. Change Monday’s Repair count in B2 from 12 to 99. B8 should update to 99. When you’re done checking, type 12 back into B2 and save.

Reopened formula-transposed table with weekdays as rows and workshops as columns
After reopening, the formula table remains organized by weekday.

Practice with four days of sign-in data

Expand sign-in sheet

Save the content below as a CSV, open it in Cue Office, and save it as XLSX. The original table occupies A1:E4, leaving A7 free for practicing transposition.

Workshop,Monday,Tuesday,Wednesday,Thursday
Repair,12,18,15,20
Bike clinic,9,11,14,13
Tool orientation,16,13,19,17
Original sign-in sheet and complete transposed result
Above is the original table; below is the transposed table.

From sign-in sheets to daily reporting

During the workshop, staff can log attendance by activity and use the linked view to send a daily count to colleagues. If the next session runs an extra day, give Cue AI the expanded source range and an empty destination, then spot-check the new day’s counts.

Cue Office is a free office suite. Use it to view event schedules in PDF, edit attendance workbooks in Excel (.xlsx), write handover notes in Word (.docx), and share attendance figures in PowerPoint (.pptx).

Download Cue Office for free