Is it possible to move this info over a column?

[TCyber]

I created a pivot table and have several lines that look like the example; I would like to slide the cells that start with V over to Column B but maintain their positions in correlation with the cells that start with three letters. Is it possible to do this in a pivot table or do I need to copy and paste the data to a sheet and work on it there?

CCI-000015

V-222407

DDC-000017

V-222411

CCI-000018

V-2fasdasd

V-122313

V-222432

 

[Cubist]

Try this maybe.

Book1
	A	B	C	D
1				Pivot
2				CCI-000015
3		V-222407		V-222407
4				DDC-000017
5		V-222411		V-222411
6				CCI-000018
7		V-2fasdasd		V-2fasdasd
8		V-122313		V-122313
9		V-222432		V-222432
Sheet1

Cell Formulas
Range	Formula
B2:B9	B2	=IF(LEFT(D2:D9,1)="V",D2:D9,"")
Dynamic array formulas.