Moving names from one sheet to another but not as a line

M

mtaylor

Board Regular
Joined
May 1, 2013
Messages
78
Office Version
  1. Prefer Not To Say
Platform
  1. Windows
  2. MacOS
Ok, here goes

Google Sheets

Names of students in a column A starting A3 and going down to A30

Names to transcribe across to Sheet 2 but instead of appearing in Column X as a line I want them to appear and cover the page, for example A1:E5

Is this possible?

Please and thank you
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
You must log in or register to reply here.

Similar threads

S
  • Solved
Microsoft Forms Registering for Sports League
Replies
1
Views
224
SteveP29
S
K
  • Question Question
How to extract partial data from one sheet to another using a single formula in Google Sheets
Replies
0
Views
212
KBurn123
K
J
  • Solved
Formula to determine which column fields are marked as NOT blank and input corresponding column value in cell on Google Sheets
Replies
1
Views
1K
jasonb75
J
S
  • Question Question
how to replace a cell num value with another cell num value by using a formula?
Replies
0
Views
527
ssonawane
S
A
  • Question Question
MS Word macro to find text from Excel list in Word doc, then copy and paste chunks from Word doc to new Word doc
Replies
3
Views
2K
amaneta67
A

Forum statistics

Threads
1,223,948
Messages
6,175,575
Members
452,652
Latest member
eduedu

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top