VBA required for Transposing COL to ROW

[NeoSez]

Not sure how to describe it, but I need the data to auto transpose to another Workbook as it is tedious and time consuming to enter it manually from Columns to rows.
The explanations are below each table. Please feel free to ask if you are not clear.

- Each row must be transferred and transposed to "SAMPLOID.XLSX" Workbook
- Columns G-M must each have it's own row. Columns can vary. Sometimes there are more data and can go from G-Z. Sometimes there are less columns, example from G-I only.

SAMPLE Original.xlsx | SHEET1

A	B	C	D	E	F	G	H	I	J	K	L	M
		SHEET2!B1	SHEET2!B2
		Sheet2!B4
						G3-T-I-2	G3-T-I-3	G3-T-I-4	G3-T-I-5	G3-T-I-6	G3-T-I-7	G3-T-I-8
						VIA RAIL	AMTRAK	SHINKASEN	DUO RAIL	T TRAK	BART	MTR
AAA	BBB	CCC	DDD	EEE	FFF	Enter QTY	Enter QTY	Enter QTY	Enter QTY	Enter QTY	Enter QTY	Enter QTY
1	110010	VICTORIA	WEST	VC	77453	1	2	3				5
2	110011	MELBOURNE	SOUTH	MB	34654	1
3	110014	NEW YORK	EAST	NY	63634	1		2			4	4
4	110015	MIAMI	SOUTH	MM	42745					4	6	6
5	110016	BOSTON	EAST	BS	34689	1	2	2	2	2	2	2
SHEET1

SAMPLE Original.xlsx | SHEET2

PASSENGER #	Sheet1$C$1	TRIP SUMMARY
PASSENGER NAME	Sheet1$D$1
SECTION	Coach
CHARGE CARD	Sheet1$C$2
G-CODE	TRAIL	QTY	PRICE	TOTAL
G3-T-I-2	VIA RAIL	0	$100.00	$0.00
G3-T-I-3	AMTRAK	0	$101.00	$0.00
G3-T-I-4	SHINKASEN	0	$102.00	$0.00
G3-T-I-5	DUO RAIL	0	$103.00	$0.00
G3-T-I-6	T TRAK	0	$104.00	$0.00
G3-T-I-7	BART	0	$105.00	$0.00
G3-T-I-8	MTR	0	$106.00	$0.00
SHEET2

SAMPLOID.xlsx
Please take note of the Column Heading Lettering as it is relevant. I hid some columns that were not relevant this.
- Each row is transferred and transposed from "SAMPLE ORIGINAL.XLSX" Workbook.
- Columns G-M must each have it's own row. Columns can vary. As soon as the SAMPLE ORIGINAL.XLSX SHEET2! BBB (corresponds to CCC) changes, then a blank row must be inserted before the next BBB begins.
- Take note that Column B (AAA) numbering is restarted for each new section.
- Price Lookup is from SAMPLE ORIGINAL.XLSX SHEET2! , based on the G-Code.
Want an easy-to-modify VBA script so it can be easily modified for a different setup, if so required. Remember I'm a noob.
Hopefully I have explained this as clearly as possible. I really appreciate your help. Thanking you in advance.

B	C	D	E												Q	R				V	W
AAA	BBB	CCC	DDD												G-Code #*	TRAIL*				QTY*	Price* From Samploid|Sheet2
1	110010	Victoria	WEST												G3-T-I-2	VIA RAIL				1	$ 100.00
2	110010	Victoria	WEST												G3-T-I-3	AMTRAK				2	$ 101.00
3	110010	Victoria	WEST												G3-T-I-4	SHINKASEN				3	$ 102.00
4	110010	Victoria	WEST												G3-T-I-8	MTR				5	$ 106.00
1	110011	MELBOURNE	SOUTH												G3-T-I-2	VIA RAIL				2	$ 100.00
1	110014	NEW YORK	EAST												G3-T-I-2	VIA RAIL				2	$ 100.00
2	110014	NEW YORK	EAST												G3-T-I-4	SHINKASEN				2	$ 102.00
3	110014	NEW YORK	EAST												G3-T-I-7	BART				4	$ 105.00
4	110014	NEW YORK	EAST												G3-T-I-8	MTR				4	$ 106.00
1	110015	MIAMI	SOUTH												G3-T-I-6	T TRAK				2	$ 104.00
2	110015	MIAMI	SOUTH												G3-T-I-7	BART				6	$ 105.00
3	110015	MIAMI	SOUTH												G3-T-I-8	MTR				8	$ 106.00
1	110016	BOSTON	EAST												G3-T-I-2	VIA RAIL				2	$ 100.00
2	110016	BOSTON	EAST												G3-T-I-3	AMTRAK				2	$ 101.00
3	110016	BOSTON	EAST												G3-T-I-4	SHINKASEN				2	$ 102.00
4	110016	BOSTON	EAST												G3-T-I-5	DUO RAIL				2	$ 103.00
5	110016	BOSTON	EAST												G3-T-I-6	T TRAK				4	$ 104.00
6	110016	BOSTON	EAST												G3-T-I-7	BART				6	$ 105.00
7	110016	BOSTON	EAST												G3-T-I-8	MTR				6	$ 106.00

 

[NeoSez]

How do I modify this script to accomodate this post?

VBA required for Columns to rows

Here are the requirements I am trying to figure out a VBA code for. Please help write a VBA code based on the requirements below. Thank you. Copy from WRKBOOK 1 to WRKBOOK 2 WRKBOOK 1 Columns G, H, I, J - Must create a new line if there is an entry, as shown in WRKBOOK 2 WRKBOOK 2 Columns...

www.mrexcel.com