All my data is in column A, is there a formula to move some data to column B

PETRODATAjames

New Member
Joined
Aug 20, 2022
Messages
21
Office Version
  1. 365
Platform
  1. Windows
Hola!

I need a formula that will keep A1 as A1, but
moves B2 to A1
moves A3 to A2
moves A4 to B2
moves A5 to A3
moves A6 to B3
and so on.
I would also need to make sure that this formula will always work no matter how many rows are in column A.

Gràcies
James E.

report-credit-expiration-details_Tribe Fitness Seattle.csv
A
110 Classes
2$300.00
3 10 Private 60 Minute Training Sessions
4$750.00
5 12 Private training sessions
6$960.00
7 1 Class
8$39.00
9 1 Private training session
10$105.00
11 20 Classes
12$500.00
13 20 Private training sessions
14$1,500.00
15 2 Private Training Sessions Gift Card
16$210.00
17 2 Week Intro (for previous members)
18$125.00
19 2 Week Intro Pass
20$125.00
21 4 Private training sessions
22$380.00
23 5 Classes
24$175.00
25 5 Class Pack Gift Card
26$176.41
27 8 Private training sessions
28$720.00
29 Christmas Class Pack
30$225.00
31 Christmas Personal Training Gift Card
32$100.00
33 Private 30 min 1:1 (10 pack)
34$450.00
35 TRIBE Instructor Training Deposit
36$500.00
37 TRIBE Reformer Certification Training
38$0.00
Sheet1
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
How about
Fluff.xlsm
ABC
110 Classes10 Classes300
2300 10 Private 60 Minute Training Sessions750
3 10 Private 60 Minute Training Sessions 12 Private training sessions960
4750 1 Class39
5 12 Private training sessions 1 Private training session105
6960 20 Classes500
7 1 Class 20 Private training sessions1500
839 2 Private Training Sessions Gift Card210
9 1 Private training session 2 Week Intro (for previous members)125
10105 2 Week Intro Pass125
11 20 Classes 4 Private training sessions380
12500 5 Classes175
13 20 Private training sessions 5 Class Pack Gift Card176.41
141500 8 Private training sessions720
15 2 Private Training Sessions Gift Card Christmas Class Pack225
16210 Christmas Personal Training Gift Card100
17 2 Week Intro (for previous members) Private 30 min 1:1 (10 pack)450
18125 TRIBE Instructor Training Deposit500
19 2 Week Intro Pass TRIBE Reformer Certification Training0
20125
21 4 Private training sessions
22380
23 5 Classes
24175
25 5 Class Pack Gift Card
26176.41
27 8 Private training sessions
28720
29 Christmas Class Pack
30225
31 Christmas Personal Training Gift Card
32100
33 Private 30 min 1:1 (10 pack)
34450
35 TRIBE Instructor Training Deposit
36500
37 TRIBE Reformer Certification Training
380
39
Sheet5
Cell Formulas
RangeFormula
B1:C19B1=WRAPROWS(FILTER(A1:A1000,A1:A1000<>""),2,"")
Dynamic array formulas.
 
Upvote 0

Forum statistics

Threads
1,223,236
Messages
6,170,912
Members
452,366
Latest member
TePunaBloke

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