rwmill9716
Active Member
- Joined
- May 20, 2006
- Messages
- 495
- Office Version
- 2013
- Platform
- Windows
I have stock trading results in Columns AX through BD (hundreds of rows). I need formula for Columns BE through BI that will let me rearrange the data as shown. Essentially, I'm taking data that's presented as 1 row per symbol and converting it to 2 rows per symbol then rearranging the data as shown into those two rows: the 1/2 position trade results (date and profit) are moved to single columns.
Thanks for your help,
Ric
Thanks for your help,
Ric
Excel 2010 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AX | AY | AZ | BA | BB | BC | BD | BE | BF | BG | BH | BI | |||
20 | Symbol | Date Purchased | Price | Date 1st half sold | Profit | Date 2nd half sold | Profit | Symbol | Date Purchased | Price | Date 1/2 Position Sold | Profit | ||
21 | CC | 01/05/17 | $20.82 | 1/10/2017 | 2.25 | 1/10/2017 | $2.45 | CC | 1/5/2017 | $20.82 | 1/10/2017 | $2.25 | ||
22 | THO | 01/12/17 | $100.29 | 1/13/2017 | $2.50 | 1/19/2016 | $2.00 | 1/10/2017 | $2.45 | |||||
23 | SF | 01/12/17 | $48.69 | 1/13/2017 | $3.00 | 1/13/2017 | $3.00 | THO | 1/12/2017 | $100.29 | 1/13/2017 | $2.50 | ||
24 | PAA | 01/19/17 | $30.53 | 1/24/2017 | $1.75 | 1/25/2017 | $1.50 | 1/19/2017 | $2.00 | |||||
25 | WDC | 01/19/17 | $72.01 | 1/20/2017 | $1.25 | 1/20/2017 | $1.25 | SF | 1/12/2017 | $48.69 | 1/13/2017 | $3.00 | ||
26 | SCHN | 01/25/17 | $23.80 | 1/31/2017 | $0.55 | 2/1/2017 | $0.55 | 1/13/2017 | $3.00 | |||||
2016 (2) |